use Den_Database;
Create Table Patient(
PID varchar(3),
Forename varchar(20),
Surname varchar(25),
Gender Varchar(10),
Age integer(3),
Address varchar(100),
Post_Code varchar(7),
Date of Visit date(8),
Contact No integer(25),
);

use Den_Database;
Create Table Receptionist(
EID varchar(3),
Rec-Address varchar(100),
Gender varchar(10),
Rec-Name varchar(50),
Rec-Contact No integer(25),
);

use Den_Database;
Create Table Record(
Appointment date(8),
Patient-ID varchar(6),
Description varchar(150),
Record-No integer(4),
);

use Den_Database;
Create Table Room(
RoomID varchar(3),
Room Type varchar(50),
Period varchar(8),
);

use Den_Database;
Create Table Medicine(
Quantity integer(3),
Price integer(8),
Med Code integer(7),
);

use Den_Database;
Create Table Nurse(
EID varchar(3),
Age integer (3),
Nur-Address varchar(100),
Gender varchar(10),
Nur-Name varchar(50),
Nur-ContactNo varchar(25),
);

use Den_Database;
Create Table Dentist(
EID varchar(3),
Age integer (3),
Doc-Address varchar(100),
Gender varchar(10),
Doc-Name varchar(50),
Doc-ContactNo varchar(25),
);

use Den_Database;
Create Table Hygienists(
EID varchar(3),
Age integer (3),
Doc-Address varchar(100),
Gender varchar(10),
Hyg-Name varchar(50),
Hyg-ContactNo integer(25),
);
